﻿/*CREATE TABLE [dbo].[Tecnicos] (
    [TecnicoGuid]      UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [TecnicoId]        INT              NOT NULL,
    [EstadoGuid]       UNIQUEIDENTIFIER NOT NULL,
    [EstadoId]         INT              NOT NULL,
    [MunicipioGuid]    UNIQUEIDENTIFIER NOT NULL,
    [MunicipioId]      INT              NOT NULL,
    [AcreditacionGuid] UNIQUEIDENTIFIER NOT NULL,
    [AcreditacionId]   INT              NOT NULL,
    [JuntaGuid]        UNIQUEIDENTIFIER NULL,
    [JuntaId]          INT              NULL,
    [CicloGuid]        UNIQUEIDENTIFIER NOT NULL,
    [CicloId]          INT              NOT NULL,
    [Nombre]           NVARCHAR (250)   NOT NULL,
    [Email]            NVARCHAR (250)   NULL,
    [Telefono]         NVARCHAR (50)    NULL,
    [Celular]          NVARCHAR (50)    NULL,
    [Domicilio]        NTEXT            NULL,
    [Registro]         NVARCHAR (50)    NULL,
    [Vigencia]         DATETIME         NULL,
    [Status]           BIT              NOT NULL,
    [LastEditDate]     DATETIME         NULL,
    [CreationDate]     DATETIME         NULL
);*/


GO
/*ALTER TABLE [dbo].[Tecnicos] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = OFF);*/



